package recipe;

import common.db.DBExecute;
import common.main.MainBean;

public class RecipeListBean extends MainBean
{
	public void funcExecute() throws Exception
	{	
		queryBuffer = new StringBuffer("");
		queryBuffer.append("SELECT ROWNUM DISP_NUM, SEQ, TITLE, CONTENT, GNO, RECOMMEND, COUNT , TO_CHAR(UPD_DATE, 'YYYY-MM-DD') UPD_DATE ");
		queryBuffer.append("FROM RECIPE ");
		queryBuffer.append("WHERE USE_YN='Y' ");
		queryBuffer.append("ORDER BY SEQ");		
		
		DBExecute dbe = new DBExecute(queryBuffer.toString());
		outputList = dbe.getDataList();
	}
}
